{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes Balance","Cumulative Defaults","Collateral Tables "],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":7,"defined_names":24,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes Balance","index":0,"n_rows":89,"n_cols":6,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C3:F3)","v":408900000},189325000,200000000,10875000,8700000]
["Invested Amount as at Previous Payment Date:  17 August 2020",{"$f":"SUM(C4:F4)","v":408900000},189325000,200000000,10875000,8700000]
["Stated Amount as at Previous Payment Date:  17 August 2020",408900000,189325000,200000000,10875000,8700000]
["Principal Payments to Noteholders on Payment Date",34777204.240000002,34777204.240000002,0,0,0]
["Gross Aggregate Charge-Offs",{"$f":"SUM(C7:G7)","v":0},0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 November 2020",374122795.75999999,154547795.75999999,200000000,10875000,8700000]
["Stated Amount as at Payment Date:  16 November 2020",374122795.75999999,154547795.75999999,200000000,10875000,8700000]
["Bond Factor at Payment Date:  16 November 2020",null,0.8163094982701703,1,1,1]
["Coupon Margin",null,9.4999999999999998E-3,1.0999999999999999E-2,0,0]
["Coupon Rate (3 month BBSW + margin)",null,1.0499999999999999E-2,1.2E-2,1E-3,1E-3]
["Days in Coupon Period",null,91,91,91,91]
["Coupon Entitlement to be paid out on the current Payment Date: 16 November 2020",null,495616.54,598356.16,2711.3,2169.04]
[]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C26:G26)","v":408900000},189325000,200000000,10875000,8700000]
["Invested Amount as at Previous Payment Date:  16 November 2020",{"$f":"SUM(C27:G27)","v":374122795.75999999},154547795.75999999,200000000,10875000,8700000]
["Stated Amount as at Previous Payment Date:  16 November 2020",374122795.75999999,154547795.75999999,200000000,10875000,8700000]
["Principal Payments to Noteholders on Payment Date",28459951.68,28459951.68,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(C33:G33)","v":0},0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 February 2021",345662844.07999998,126087844.07999998,200000000,10875000,8700000]
["Stated Amount as at Payment Date:  16 February 2021",345662844.07999998,126087844.07999998,200000000,10875000,8700000]
["Bond Factor at Payment Date:  16 February 2021",null,0.66598623573220639,1,1,1]
["Coupon Margin",null,9.4999999999999998E-3,1.0999999999999999E-2,0,0]
["Coupon Rate (3 month BBSW + margin)",null,9.7000000000000003E-3,1.12E-2,2.0000000000000001E-4,2.0000000000000001E-4]
["Days in Coupon Period",null,92,92,92,92]
["Coupon Entitlement to be paid out on the current Payment Date: 16 February 2021",null,377858.78,564602.74,548.22,438.58]
[]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C49:F49)","v":408900000},189325000,200000000,10875000,8700000]
["Invested Amount as at Previous Payment Date:  16 February 2021",{"$f":"SUM(C50:F50)","v":345662844.07999998},126087844.07999998,200000000,10875000,8700000]
["Stated Amount as at Previous Payment Date:  16 February 2021",345662844.07999998,126087844.07999998,200000000,10875000,8700000]
["Principal Payments to Noteholders on Payment Date",62919663.530000001,62919663.530000001,0,0,0]
["Gross Aggregate Charge-Offs",0,{"$f":"+D53","v":0},0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(C59:F59)","v":0},0,0,0,0]
["Invested Amount as at Payment Date:  17 May 2021",{"$f":"SUM(C60:F60)","v":282743180.54999995},63168180.549999982,200000000,10875000,8700000]
["Stated Amount as at Payment Date:  17 May 2021",{"$f":"SUM(C61:F61)","v":282743180.54999995},63168180.549999982,200000000,10875000,8700000]
["Bond Factor at Payment Date:  17 May 2021",null,0.33364944170077898,1,1,1]
["Coupon Margin",null,9.4999999999999998E-3,1.0999999999999999E-2,0,0]
["Coupon Rate (3 month BBSW + margin)",null,9.6030000000000004E-3,1.1103E-2,1.03E-4,1.03E-4]
["Days in Coupon Period",null,90,90,90,90]
["Coupon Entitlement to be paid out on the current Payment Date: 17 May 2021",null,298558.74,547545.21,276.2,220.96]
[]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C72:G72)","v":408900000},189325000,200000000,10875000,8700000]
["Invested Amount as at Previous Payment Date:  17 May 2021",{"$f":"SUM(C73:G73)","v":282743180.54999995},63168180.549999982,200000000,10875000,8700000]
["Stated Amount as at Previous Payment Date:  17 May 2021",282743180.54999995,63168180.549999982,200000000,10875000,8700000]
["Principal Payments to Noteholders on Payment Date",22830302.510000002,22830302.510000002,0,0,0]
["Gross Aggregate Charge-Offs",{"$f":"SUM(C76:G76)","v":0},0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(C79:G79)","v":0},0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 August 2021",259912878.03999996,40337878.039999977,200000000,10875000,8700000]
["Stated Amount as at Payment Date:  16 August 2021",259912878.03999996,40337878.039999977,200000000,10875000,8700000]
["Bond Factor at Payment Date:  16 August 2021",null,0.21306155045556571,1,1,1]
["Coupon Margin",null,9.4999999999999998E-3,1.0999999999999999E-2,0,0]
["Coupon Rate (3 month BBSW + margin)",null,9.894E-3,1.1394E-2,3.9399999999999998E-4,3.9399999999999998E-4]
["Days in Coupon Period",null,91,91,91,91]
["Coupon Entitlement to be paid out on the current Payment Date: 16 August 2021",null,155818.42000000001,568139.18000000005,1068.25,854.6]

{"sheet":"Cumulative Defaults","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2020-10-01",0,0,{"$f":"+B4-C4","v":0}]
["2021-01-01",0,0,{"$f":"+B5-C5","v":0}]
["2021-04-01",4.1450255172413797E-4,0,{"$f":"+B6-C6","v":4.1450255172413797E-4}]
["2021-07-01",{"$f":"+B6+'Collateral Tables '!E9/435000000","v":2.1661076551724137E-3},{"$f":"+C6+'Collateral Tables '!E23/435000000","v":4.4360710344827588E-4},{"$f":"+B7-C7","v":1.7225005517241378E-3}]

{"sheet":"Collateral Tables ","index":2,"n_rows":247,"n_cols":19,"rows_kept":247,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2020-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2021-07-31",null,null,null,"2021-04-30",null,null,null,"2021-01-31",null,null,null,"2020-10-31"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":308843180.5500015},null,null,null,371762844.08000153,null,null,null,400222795.76000142,null,null,null,434999973.20000142]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN(([2]Sheet1!$B$3+[3]Sheet1!$B$3+[4]Sheet1!$B$3),'[1]16 Aug 21'!$H$23)","v":18901918.629999992},null,null,null,59828601.879999973,null,null,null,25136419.830000006,null,null,null,26305441.499999996]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[1]16 Aug 21'!$H$23-'Collateral Tables '!E7","v":3472716.4100000151},null,null,null,2910753.0400000513,null,null,null,3323531.8499999158,null,null,null,8471735.9399999939]
[{"$f":"SUM(E9:Q9)","v":942256.83},"Charge-Offs",null,null,{"$f":"'[1]16 Aug 21'!$H$37","v":761948.22},null,null,null,180308.61000000002,null,null,null,0,null,null,null,0]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":285706597.29000145},null,null,null,308843180.5500015,null,null,null,371762844.08000153,null,null,null,400222795.76000142]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[5]Summary!$B$4","v":3089},null,null,null,3260,null,null,null,3379,null,null,null,3459]
[null,"Dollar value of contracts",null,null,{"$f":"[5]Summary!$B$5","v":285706597.29000068},null,null,null,308843180.5499993,null,null,null,371762844.08000028,null,null,null,400222795.76000023]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$19","v":169},null,null,null,118,null,null,null,80,null,null,null,81]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$20","v":6346762.1999999993},null,null,null,8489230.9399999958,null,null,null,6207942.7200000016,null,null,null,11089284.780000003]
[]
[{"$f":"SUM(E23:Q23)","v":192969.09},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[5]Summary!$C$16","v":192969.09},null,null,null,0,null,null,null,0,null,null,null,0]
[{"$f":"SUM(E24:Q24)","v":0},"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[6]Sheet1!$W$3091","v":55.739992390288997},null,null,null,55.455838893218491,null,null,null,54.836712581510767,null,null,null,54.458787730372293]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[6]Sheet1!$X$3091","v":32.574078748533445},null,null,null,34.945628768910865,null,null,null,36.785248881480932,null,null,null,39.320110754577776]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[6]Sheet1!$AI$3091","v":3.7181210890735616E-2},null,null,null,3.8809459520592636E-2,null,null,null,3.738139172226735E-2,null,null,null,3.7554148495446298E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":23.165913641755552},null,null,null,20.510210124307626,null,null,null,18.051463700029835,null,null,null,15.138676975794517]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":92491.614532211286},null,null,null,94737.171947852548,null,null,null,110021.55788102998,null,null,null,115704.76893899978]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[6]Sheet1!$AA$3091/100","v":2.270699088694228E-2},null,null,null,2.2731504735293059E-2,null,null,null,2.2726608213105511E-2,null,null,null,2.2793137532541325E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":3088},{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":1243.8200000000038},{"$f":"F34/F$50","v":4.3534871500971666E-6},null,3244,96795.249999999985,3.1341229496349406E-4,null,3368,669139.2699999999,1.7999089490933814E-3,null,3448,608582.11,1.5206083122885025E-3]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":31314.589999999989},1.0960401438758081E-4,null,10,74360.209999999992,2.4077012115850065E-4,null,3,77257.799999999988,2.0781474327051026E-4,null,8,239593.93000000002,5.9865138252563753E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0,null,2,37814.990000000005,1.224407478664664E-4,null,4,131816.78000000003,3.5457222823385265E-4,null,2,134580.25,3.3626332988964257E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0,null,2,115620.04999999999,3.7436491164901097E-4,null,2,41551.660000000003,1.1176926543809858E-4,null,1,5840.8499999999985,1.459399629875794E-5]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0,null,0,0,0,null,2,3518.8499999999995,9.4653084783340328E-6,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0,null,2,122531.52000000002,3.9674348574506789E-4,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":3089},{"$f":"SUM(F34:F39)","v":32558.409999999993},{"$f":"SUM(G34:G39)","v":1.1395750153767797E-4},null,3260,447122.01999999996,1.4477315613825399E-3,null,3379,923284.35999999987,2.4835304945141769E-3,null,3459,988597.14,2.4701170210025408E-3]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":1.0960401438758081E-4},null,null,"> 30 days",1.1343192664190458E-3,null,null,"> 30 days",6.8362154542079548E-4,null,null,"> 30 days",9.4950870871403803E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":3088},{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":285598376.65000069},{"$f":"F44/F$50","v":0.99962121756715983},null,3244,306751454.69999921,0.99322722345277326,null,3368,370345507.02000022,0.99618752362542429,null,3448,398525593.33000022,0.99575935591880238]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":108220.64},{"$f":"F45/F$50","v":3.787824328401939E-4},null,10,955937.27,3.0952189661356037E-3,null,3,457915.85,1.231741841047085E-3,null,8,1107284.19,2.7666694694322208E-3]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},0,null,2,219395.31,7.1037770563459697E-4,null,4,653099.60000000009,1.756764051061161E-3,null,2,543586.31000000006,1.3582092668353904E-3]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},{"$f":"F47/F$50","v":0},null,2,348198.83,1.1274292324665058E-3,null,2,222711.15999999997,5.9906782925319552E-4,null,1,46331.93,1.1576534492998659E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},{"$f":"F48/F$50","v":0},null,0,0,0,null,2,83610.45,2.2490265321406817E-4,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,2,568194.43999999994,1.8397506429902017E-3,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":3089},{"$f":"SUM(F44:F49)","v":285706597.29000068},{"$f":"SUM(G44:G49)","v":1},null,3260,308843180.54999918,1.0000000000000002,null,3379,371762844.08000028,0.99999999999999989,null,3459,400222795.76000023,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":3.787824328401939E-4},null,null,"> 30 days",6.7727765472269091E-3,null,null,"> 30 days",3.8124763745755099E-3,null,null,"> 30 days",4.2406440811975981E-3]
[null,null,null,null,null,"> 60 days",{"$f":"SUM(G46:G49)","v":0},null,null,"> 60 days",3.6775575810913045E-3,null,null,"> 60 days",2.5807345335284249E-3,null,null,"> 60 days",1.4739746117653769E-3]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":0},null,null,">90 days",2.9671798754567075E-3,null,null,">90 days",8.2397048246726366E-4,null,null,">90 days",1.1576534492998659E-4]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F56/F$64","v":0.24627373986950885},{"$f":"IFERROR(VLOOKUP($A56,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":70362032.219999984},null,null,0.24998360631602445,77205732.060000047,null,null,0.24533885742592679,91207871.400000185,null,null,0.24685968916984516,98798874.960000023]
["VIC","Victoria",null,null,{"$f":"F57/F$64","v":0.2171302887592485},{"$f":"IFERROR(VLOOKUP($A57,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":62035555.970000029},null,null,0.22236335990226544,68675407.309999987,null,null,0.21677229686422927,80587885.599999949,null,null,0.21323032049672458,85339635.009999946]
["QLD","Queensland",null,null,0.11230010435297356,{"$f":"IFERROR(VLOOKUP($A58,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":32084880.689999998},null,null,0.11639922868292057,35949107.99999997,null,null,0.10566504901051051,39282339.139999978,null,null,0.10911006482545886,43668335.189999983]
["SA","South Australia",null,null,0.20569304985403983,{"$f":"IFERROR(VLOOKUP($A59,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":58767861.360000052},null,null,0.19970919351419694,61678822.510000005,null,null,0.20647734487818203,76760604.969999984,null,null,0.2000584061883722,80067934.640000001]
["NT","Northern Territory",null,null,0,{"$f":"IFERROR(VLOOKUP($A60,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
["ACT","Australian Capital Territory",null,null,1.2712366583237885E-3,{"$f":"IFERROR(VLOOKUP($A61,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":363200.7},null,null,1.2329193065616485E-3,380778.72,null,null,1.2097697689853544E-3,449747.44999999995,null,null,1.1397817036727404E-3,456166.62]
["TAS","Tasmania",null,null,1.6410803441269037E-2,{"$f":"IFERROR(VLOOKUP($A62,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":4688674.8099999996},null,null,1.7221919358970286E-2,5318872.3499999996,null,null,1.5713687591498264E-2,5841765.1900000004,null,null,1.5793035821453624E-2,6320732.9499999974]
["WA","Western Australia",null,null,0.20092077706463649,{"$f":"IFERROR(VLOOKUP($A63,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":57404391.539999969},null,null,0.19308977291906076,59634459.599999979,null,null,0.20882299446066782,77632630.329999968,null,null,0.21380870179447287,85571116.39000006]
[null,"Total",null,null,{"$f":"SUM(E56:E63)","v":1},{"$f":"SUM(F56:F63)","v":285706597.29000002},null,null,1.0000000000000002,308843180.54999995,null,null,1,371762844.08000004,null,null,1,400222795.75999999]
["AG",null,null,null,null,null,{"$f":"E13-F64","v":1.430511474609375E-6},null,null,null,1.5497207641601563E-6,null,null,null,1.4901161193847656E-6,null,null,null,1.430511474609375E-6]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F67/F$70","v":0.96428655429456855},{"$f":"IFERROR(VLOOKUP($A$67,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":275503030.24000055},null,null,0.96144750394424727,296936505.04999989,null,null,0.96306499700372106,358031782.32000077,null,null,0.96151115188042091,384818681.36000061]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F68/F$70","v":3.5713445705431439E-2},{"$f":"IFERROR(VLOOKUP($A$68,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":10203567.050000001},null,null,3.8552496055752748E-2,11906675.500000004,null,null,3.6935002996278908E-2,13731061.759999996,null,null,3.848884811957913E-2,15404114.4]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F69/F$70","v":0},{"$f":"IFERROR(VLOOKUP($A$69,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E67:E69)","v":1},{"$f":"SUM(F67:F69)","v":285706597.29000056},{"$f":"F64-F70","v":-5.3644180297851563E-7},null,1,308843180.54999989,0,null,1,371762844.08000076,-7.152557373046875E-7,null,1,400222795.76000059,-5.9604644775390625E-7]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F73/F$111,0)","v":0.10271496310675897},{"$f":"IFERROR(VLOOKUP($A73,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":29346342.600000005},null,null,0.10616665409807113,32788847.11999999,null,null,9.97148357892991E-2,37070270.950000003,null,null,0.10041685507614133,40189114.480000019]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,0.10174142895445622,{"$f":"IFERROR(VLOOKUP($A74,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":29068197.469999984},null,null,9.9566226572458408E-2,30750350.089999989,null,null,9.9741663833464389E-2,37080244.619999997,null,null,9.7749299351403862E-2,39121497.869999997]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,9.6395889913753613E-3,{"$f":"IFERROR(VLOOKUP($A75,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":2754094.169999999},null,null,1.0002692448959108E-2,3089263.35,null,null,9.6298466805079998E-3,3580019.1900000009,null,null,9.7833235424900616E-3,3915509.0999999982]
["4WD Vehicle","4WD Vehicle",null,null,3.2963121920634858E-3,{"$f":"IFERROR(VLOOKUP($A76,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":941778.1399999999},null,null,3.0493732719720228E-3,941778.1399999999,null,null,3.1278335597996801E-3,1162812.2999999998,null,null,2.9054124660537806E-3,1162812.2999999998]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,4.7623358190042854E-2,{"$f":"IFERROR(VLOOKUP($A77,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":13606307.620000003},null,null,4.9007206450361086E-2,15135541.509999998,null,null,4.5031988313488994E-2,16741220.049999991,null,null,4.6006634867049409E-2,18412904.030000005]
["BACKHOE","BACKHOE",null,null,1.1027340740060233E-4,{"$f":"IFERROR(VLOOKUP($A78,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":31505.840000000011},null,null,3.4264917169789174E-4,105824.85999999996,null,null,3.2529843131385157E-4,120933.86999999998,null,null,3.622858606158672E-4,144995.06]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,4.065597693640155E-2,{"$f":"IFERROR(VLOOKUP($A79,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":11615680.830000011},null,null,4.0991785887758647E-2,12660033.529999988,null,null,4.0858043055887951E-2,15189502.289999997,null,null,4.0605957487102856E-2,16251429.830000004]
["COMBINES","COMBINES",null,null,0.31151667295823821,{"$f":"IFERROR(VLOOKUP($A80,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":89002368.63000004},null,null,0.30539115988261389,94317977.13000007,null,null,0.32456910520093429,120662733.65000005,null,null,0.32708290993624445,130906036.66]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,4.5144721971218695E-3,{"$f":"IFERROR(VLOOKUP($A81,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1289814.49},null,null,4.954302171332174E-3,1530102.44,null,null,4.8382508328695178E-3,1798681.8900000006,null,null,5.216192436104731E-3,2087639.1199999999]
["COMPACT WHEEL LOADER","COMPACT WHEEL LOADER",null,null,6.6122809830759278E-4,{"$f":"IFERROR(VLOOKUP($A82,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":188917.23000000004},null,null,6.9796966090077388E-4,215563.17000000004,null,null,6.511828006886709E-4,242085.57000000007,null,null,6.7083979934266834E-4,268485.38000000006]
["CRAWLER EXCAVATOR","CRAWLER EXCAVATOR",null,null,6.9680338812032026E-3,{"$f":"IFERROR(VLOOKUP($A83,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1990813.25},null,null,7.2480528986055975E-3,2238511.71,null,null,7.2875790928073336E-3,2709251.1300000004,null,null,7.4809969639896279E-3,2994065.52]
["CRAWLER  DOZER","CRAWLER  DOZER",null,null,1.3992673035625157E-4,{"$f":"IFERROR(VLOOKUP($A84,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":39977.990000000005},null,null,2.5634025610995472E-4,79168.94,null,null,2.1295549369899797E-4,79168.94,null,null,1.9781217071771932E-4,79168.94]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.9672039929463394E-2,{"$f":"IFERROR(VLOOKUP($A85,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":5620431.5900000008},null,null,1.9440141431350113E-2,6003955.1099999994,null,null,1.9310974171628421E-2,7179102.6800000034,null,null,1.8602632780729052E-2,7445197.7000000011]
["DRILL","DRILL",null,null,1.0240496466486053E-3,{"$f":"IFERROR(VLOOKUP($A86,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":292577.74},null,null,1.0047484922522435E-3,310309.71999999997,null,null,9.5839413667528459E-4,356295.33,null,null,9.2039425015884085E-4,368362.76]
["DUMP TRUCKS","DUMP TRUCKS",null,null,8.5304435498427409E-5,{"$f":"IFERROR(VLOOKUP($A87,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":24372.039999999994},null,null,8.3891280856063531E-5,25909.249999999993,null,null,7.3774559337344727E-5,27426.639999999992,null,null,7.2270920863150989E-5,28924.469999999994]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,2.2253206822335148E-4,{"$f":"IFERROR(VLOOKUP($A88,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":63578.879999999917},null,null,3.2863102179964875E-4,101495.44999999992,null,null,4.1160891260846714E-4,153020.89999999991,null,null,5.266989342766165E-4,210796.91999999987]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,1.3468778237885955E-3,{"$f":"IFERROR(VLOOKUP($A89,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":384811.88},null,null,1.2929494162340828E-3,399318.61000000004,null,null,1.2051428138514795E-3,448027.32,null,null,1.2643309810454664E-3,506014.07999999996]
["FRONT END LOADER","FRONT END LOADER",null,null,7.1214095834643617E-4,{"$f":"IFERROR(VLOOKUP($A90,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":203463.37},null,null,7.1114579771154325E-4,219632.52999999997,null,null,6.5042543613628577E-4,241804.01,null,null,6.4381105406728189E-4,257667.86]
["FRONTS","FRONTS",null,null,3.6710548861963919E-3,{"$f":"IFERROR(VLOOKUP($A91,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1048844.5999999999},null,null,3.4843195115515386E-3,1076108.3199999998,null,null,3.7934741528298675E-3,1410272.74,null,null,3.7781679255140701E-3,1512108.9300000002]
["GRADER","GRADER",null,null,0,{"$f":"IFERROR(VLOOKUP($A92,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,""]
["HARVESTERS - Other","HARVESTERS - Other",null,null,2.0185119051158315E-2,{"$f":"IFERROR(VLOOKUP($A93,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":5767021.6799999988},null,null,1.9237975594666234E-2,5941517.5699999984,null,null,2.007184394251689E-2,7461965.7899999982,null,null,1.9737315724357083E-2,7899323.6799999988]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,0,{"$f":"IFERROR(VLOOKUP($A94,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,""]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,0,{"$f":"IFERROR(VLOOKUP($A95,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,""]
["MIDI CRAWLER EXCAVATOR","MIDI CRAWLER EXCAVATOR",null,null,1.1756941673245595E-3,{"$f":"IFERROR(VLOOKUP($A96,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":335903.57999999996},null,null,1.2703645885957379E-3,392343.44,null,null,1.2104676063408924E-3,450006.88,null,null,1.2680610534346844E-3,507506.94]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,4.453658550657962E-3,{"$f":"IFERROR(VLOOKUP($A97,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1272439.6300000001},null,null,5.1339828426074019E-3,1585595.5900000003,null,null,4.8973059276688101E-3,1820636.3799999997,null,null,5.1123271629609024E-3,2046069.8700000008]
["OTHER AG","OTHER AG",null,null,1.59039325766351E-2,{"$f":"IFERROR(VLOOKUP($A98,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":4543858.459999999},null,null,1.5927514705812398E-2,4919104.3,null,null,1.6285591275219412E-2,6054377.7300000023,null,null,1.6185151017445894E-2,6477666.3900000015]
["OTHER CE","OTHER CE",null,null,0,{"$f":"IFERROR(VLOOKUP($A99,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,""]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.21620548127315514,{"$f":"IFERROR(VLOOKUP($A100,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":61771332.370000005},null,null,0.21719706794413135,67079833.269999988,null,null,0.21014873520600721,78125491.480000064,null,null,0.20938034891508597,83798788.61999996]
["QUAD BIKES","QUAD BIKES",null,null,2.9860773538037601E-5,{"$f":"IFERROR(VLOOKUP($A101,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":8531.4200000000019},null,null,3.0288964073420913E-5,9354.5400000000009,null,null,2.7348295188456587E-5,10167.08,null,null,2.7407659224333244E-5,10969.17]
["ROLLER","ROLLER",null,null,4.6032981823833858E-3,{"$f":"IFERROR(VLOOKUP($A102,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":1315192.6599999997},null,null,4.5585804986620721E-3,1407886.4999999998,null,null,4.0338603329527212E-3,1499639.3899999994,null,null,3.9739405322473092E-3,1590461.5899999999]
["SCRAPERS","SCRAPERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A103,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,""]
["SKID STEER LOADER","SKID STEER LOADER",null,null,9.4636174160709022E-3,{"$f":"IFERROR(VLOOKUP($A104,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":2703817.9300000011},null,null,1.0051872294772606E-2,3104452.2099999995,null,null,9.4605499877313086E-3,3517080.97,null,null,9.8631905324232626E-3,3947473.69]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,2.3756504275295435E-4,{"$f":"IFERROR(VLOOKUP($A105,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":67873.899999999994},null,null,3.6309611823157983E-4,112139.75999999998,null,null,4.277361832474604E-4,159016.41999999993,null,null,4.90521834537694E-4,196318.01999999996]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,6.6929489908104725E-2,{"$f":"IFERROR(VLOOKUP($A106,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":19122196.820000004},null,null,6.750412779998162E-2,20848189.530000001,null,null,6.6621176415011224E-2,24767278.019999992,null,null,6.511955632239573E-2,26062330.889999993]
["Telehandlers","Telehandlers",null,null,6.0300630658916183E-4,{"$f":"IFERROR(VLOOKUP($A107,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":172282.88},null,null,6.3712638773367265E-4,196772.14,null,null,5.9256225711624652E-4,220292.63,null,null,5.5042499411278427E-4,220292.63]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,8.1519983160764013E-4,{"$f":"IFERROR(VLOOKUP($A108,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":232907.96999999997},null,null,8.0499928655458847E-4,248618.54,null,null,7.2601246815811162E-4,269904.46000000002,null,null,7.5121752979880811E-4,300654.38]
["WHEEL LOADERS","WHEEL LOADERS",null,null,2.9446038627734747E-3,{"$f":"IFERROR(VLOOKUP($A109,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":841292.75},null,null,3.0474689398156431E-3,941190,null,null,2.8457744684467125E-3,1057953.21,null,null,2.9328916354477074E-3,1173810.0899999999]
["WHEEL LOADERS (OLD)","WHEEL LOADERS (OLD)",null,null,1.3323766535695711E-4,{"$f":"IFERROR(VLOOKUP($A110,[7]Collateral!$A$1:$C$35,3,FALSE),\"\")","v":38066.879999999946},null,null,2.152943117655635E-4,66492.179999999935,null,null,2.5865836656690535E-4,96159.56999999992,null,null,3.2081828261725583E-4,128398.78999999989]
[null,"Total",null,null,{"$f":"SUM(E73:E109)","v":0.99986676233464278},{"$f":"SUM(F73:F110)","v":285706597.29000014},{"$f":"F70-F111","v":0},null,0.99978470568823441,308843180.55000007,0,null,0.9997413416334332,371762844.07999998,7.7486038208007813E-7,null,0.99967918171738313,400222795.75999987,7.152557373046875E-7]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F114/F$125,0)","v":3.91040361544744E-2},{"$f":"IFERROR(VLOOKUP($A114,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":11172281.110000022},null,null,3.466676777817556E-2,10706594.82,null,null,2.605153431609717E-2,9684992.4900000002,null,null,2.2574458590854159E-2,9034812.9300000016]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F115/F$125,0)","v":8.5793945405886946E-2},{"$f":"IFERROR(VLOOKUP($A115,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":24511896.209999993},null,null,8.6577506754017902E-2,26738872.550000001,null,null,7.6624453744145685E-2,28486124.849999998,null,null,7.3033342527365652E-2,29229608.529999986]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,8.839739921848834E-2,{"$f":"IFERROR(VLOOKUP($A116,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":25255720.140000015},null,null,8.7173572853558035E-2,26922963.500000007,null,null,7.4077485306933546E-2,27539256.62000002,null,null,7.4956081157329796E-2,29999132.359999988]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,8.1535711604008354E-2,{"$f":"IFERROR(VLOOKUP($A117,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":23295290.720000003},null,null,7.9511362162080879E-2,24556541.979999989,null,null,6.5992316824218814E-2,24533491.390000015,null,null,6.3864139026522118E-2,25559884.270000007]
["$100,001 - $125,000","$100,001 to $125,000",null,null,8.4319463003324893E-2,{"$f":"IFERROR(VLOOKUP($A118,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":24090626.860000007},null,null,8.2408354313264751E-2,25451258.250000004,null,null,5.9104842724066367E-2,21972984.430000003,null,null,5.8396196437583939E-2,23371488.999999996]
["$125,001 - $150,000","$125,001 to $150,000",null,null,8.1698971047235835E-2,{"$f":"IFERROR(VLOOKUP($A119,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":23341935.019999985},null,null,7.7175578905622613E-2,23835151.249999981,null,null,6.4208504750042528E-2,23870336.339999996,null,null,6.5373349762139973E-2,26163904.809999991]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.1183260395477863,{"$f":"IFERROR(VLOOKUP($A120,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":33806530.130000003},null,null,0.12208027311095507,37703659.830000013,null,null,0.12375492083899488,46007481.339999989,null,null,0.11717379366397136,46895623.289999992]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.19943104051659341,{"$f":"IFERROR(VLOOKUP($A121,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":56978763.980000041},null,null,0.19689571805246719,60809899.800000034,null,null,0.19385609459801606,72068493.069999963,null,null,0.18750423228016472,75043468.059999958]
["$300,001 - $400,000","$300,001 to $400,000",null,null,0.12235583361246923,{"$f":"IFERROR(VLOOKUP($A122,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":34957868.880000003},null,null,0.12975414943155042,40073684.200000018,null,null,0.15979302220750316,59405108.399999961,null,null,0.15846960513471778,63423148.409999996]
["$400,001 - $500,000","$400,001 to $500,000",null,null,6.3016587298910659E-2,{"$f":"IFERROR(VLOOKUP($A123,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":18004254.73},null,null,5.9392401079843095E-2,18342938.050000001,null,null,7.2405534384731449E-2,26917687.389999989,null,null,8.834049255705495E-2,35355878.910000004]
["$500,001+","$500,000+",null,null,3.6020972590821605E-2,{"$f":"IFERROR(VLOOKUP($A124,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":10291429.51},null,null,4.4364315558464422E-2,13701616.320000004,null,null,8.4131290305250364E-2,31276887.759999998,null,null,9.0314308862295384E-2,36145845.190000005]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E114:E124)","v":1},{"$f":"SUM(F114:F124)","v":285706597.29000008},{"$f":"F111-F125","v":0},null,1,308843180.55000007,0,null,0.99999999999999989,371762844.07999992,0,null,0.99999999999999989,400222795.75999999,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
[0,0,null,null,{"$f":"IFERROR(F128/F$138,0)","v":0.87539446040910118},{"$f":"IFERROR(VLOOKUP($A128,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":250105972.57000005},null,null,0.87213026280952111,269351484.21999973,null,null,0.87953505560560308,326978453.73999989,null,null,0.88078069978649454,352508514.12000066]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F129/F$138,0)","v":3.903150681774721E-4},{"$f":"IFERROR(VLOOKUP($A129,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":111515.58999999997},null,null,3.683462260601306E-4,113761.21999999997,null,null,3.1200517170306449E-4,115991.92999999996,null,null,2.95355040373275E-4,118207.81999999998]
["6 to 10","06 to 10",null,null,1.0310093039293986E-3,{"$f":"IFERROR(VLOOKUP($A130,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":294566.16000000003},null,null,1.002730089259211E-3,309686.34999999998,null,null,8.7357842552472458E-4,324764,null,null,8.4902527692042192E-4,339799.27]
["11 to 15","11 to 15",null,null,5.4452858798387013E-3,{"$f":"IFERROR(VLOOKUP($A131,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":1555754.0999999999},null,null,5.2878947402745262E-3,1633130.23,null,null,4.9528861727875344E-3,1841299.0499999998,null,null,4.8542276966277833E-3,1942772.5799999996]
["16 to 20","16 to 20",null,null,1.4672826493204422E-2,{"$f":"IFERROR(VLOOKUP($A132,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":4192123.3300000005},null,null,1.3943702439312295E-2,4306417.41,null,null,1.2928330349672421E-2,4806272.8599999994,null,null,1.286476691119697E-2,5148772.9799999995]
["21 to 25","21 to 25",null,null,1.5568127520293979E-2,{"$f":"IFERROR(VLOOKUP($A133,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":4447916.74},null,null,1.5115409385716492E-2,4668291.1100000003,null,null,1.4012803223764287E-2,5209439.5800000029,null,null,1.3997083947610249E-2,5601952.0700000003]
["26 to 30","26 to 30",null,null,4.0339964247662799E-2,{"$f":"IFERROR(VLOOKUP($A134,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":11525393.919999998},null,null,4.2211789416180479E-2,13036823.299999999,null,null,3.9748189162282573E-2,14776899.85,null,null,3.8710363737727869E-2,15492769.999999996]
["31 to 35","31 to 35",null,null,1.4793662519839663E-2,{"$f":"IFERROR(VLOOKUP($A135,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":4226646.9799999995},null,null,1.4240967477952633E-2,4398225.6900000004,null,null,1.2493239074210818E-2,4644522.0899999989,null,null,1.21033420917503E-2,4844033.4099999992]
["36 to 40","36 to 40",null,null,2.3976523870909448E-2,{"$f":"IFERROR(VLOOKUP($A136,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":6850251.0500000007},null,null,2.5510329533484671E-2,7878691.3099999996,null,null,2.3017527158143317E-2,8557061.3599999975,null,null,2.168696514029865E-2,8679617.8200000003]
["41+ %","41+%",null,null,8.387824687042595E-3,{"$f":"IFERROR(VLOOKUP($A137,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":2396456.85},null,null,1.0188567882238131E-2,3146669.7100000004,null,null,1.2126385656308058E-2,4508139.62,null,null,1.3858170370999935E-2,5546355.6899999995]
[null,null,null,null,{"$f":"SUM(E128:E137)","v":0.99999999999999978},{"$f":"SUM(F128:F137)","v":285706597.29000014},{"$f":"F125-F138","v":0},null,0.99999999999999967,308843180.54999983,0,null,1,371762844.07999992,0,null,1,400222795.76000065,-6.5565109252929688E-7]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B141,2)&LEFT(B141,4)","v":"Q32020"},"2020Q3",null,null,{"$f":"F141/F$166","v":0},{"$f":"IFERROR(VLOOKUP($A141,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,1.2270372032843649E-3,491088.26]
["Q42020","2020Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A142,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,0,0,null,null,6.5539597052245572E-4,243651.87,null,null,2.4926624384440078E-3,997620.32999999984]
["Q12021","2021Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A143,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,0,0,null,null,7.3349914963884892E-3,2726877.3000000003,null,null,8.5426130550800197E-3,3418948.4800000004]
["Q22021","2021Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A144,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,7.2069340693752286E-3,2225812.44,null,null,9.0784005011370298E-3,3375011.9899999998,null,null,1.0496454311211063E-2,4200920.2899999972]
["Q32021","2021Q3",null,null,1.2953803080169681E-3,{"$f":"IFERROR(VLOOKUP($A145,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":370098.7},null,null,3.7663685755615437E-3,1163217.2500000002,null,null,5.3415852111693913E-3,1985802.9100000004,null,null,6.3174864270255015E-3,2528402.0799999996]
["Q42021","2021Q4",null,null,7.3018137480475257E-3,{"$f":"IFERROR(VLOOKUP($A146,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":2086176.3599999996},null,null,8.6093969608292201E-3,2658953.54,null,null,9.2186351717884647E-3,3427146.0299999993,null,null,1.08974425400181E-2,4361404.92]
["Q12022","2022Q1",null,null,2.4589701661208014E-2,{"$f":"IFERROR(VLOOKUP($A147,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":7025439.9900000012},null,null,2.4205113276864941E-2,7475584.1700000018,null,null,3.4066566096300543E-2,12664683.499999994,null,null,3.569149606502163E-2,14284550.339999998]
["Q22022","2022Q2",null,null,1.3650656012123201E-2,{"$f":"IFERROR(VLOOKUP($A148,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3900082.48},null,null,1.7070070061483835E-2,5271974.7300000023,null,null,1.8292265481314799E-2,6800384.6400000006,null,null,1.8372218593988663E-2,7352980.6900000004]
["Q32022","2022Q3",null,null,1.4432386648092025E-2,{"$f":"IFERROR(VLOOKUP($A149,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":4123428.0800000005},null,null,1.5656898563823584E-2,4835526.3500000034,null,null,1.545770660384603E-2,5746600.9699999988,null,null,1.6054907661614513E-2,6425540.0300000058]
["Q42022","2022Q4",null,null,1.7897657451744729E-2,{"$f":"IFERROR(VLOOKUP($A150,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":5113478.8099999987},null,null,1.8758695949454729E-2,5793495.3200000003,null,null,1.7399772739547948E-2,6468588.9999999991,null,null,1.9000838134567932E-2,7604568.5600000015]
["Q12023","2023Q1",null,null,9.1899601720954044E-2,{"$f":"IFERROR(VLOOKUP($A151,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":26256322.500000004},null,null,8.7654240452355717E-2,27071414.410000011,null,null,0.10271115763194207,38184192.079999983,null,null,0.1013513524709979,40563121.639999971]
["Q22023","2023Q2",null,null,5.8789264858840874E-2,{"$f":"IFERROR(VLOOKUP($A152,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":16796480.819999997},null,null,6.5833894061676709E-2,20332349.229999993,null,null,6.2229543722292044E-2,23134632.160000004,null,null,6.0824672752018652E-2,24343420.580000002]
["Q32023","2023Q3",null,null,5.3056771155387566E-2,{"$f":"IFERROR(VLOOKUP($A153,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":15158669.550000001},null,null,5.6305924673589157E-2,17389700.859999996,null,null,5.2937414949851748E-2,19680163.939999998,null,null,5.2220377228419768E-2,20899785.370000001]
["Q42023","2023Q4",null,null,6.2431351285510944E-2,{"$f":"IFERROR(VLOOKUP($A154,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":17837048.939999998},null,null,6.0629219193552998E-2,18724920.890000015,null,null,5.7402919602712536E-2,21340272.649999999,null,null,5.972607291048522E-2,23903735.879999999]
["Q12024","2024Q1",null,null,0.1451349198559489,{"$f":"IFERROR(VLOOKUP($A155,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":41466004.100000009},null,null,0.13972301137798257,43152499.229999974,null,null,0.14252488650694203,52985457.159999996,null,null,0.14245270505328397,57012819.880000003]
["Q22024","2024Q2",null,null,5.0685051228625787E-2,{"$f":"IFERROR(VLOOKUP($A156,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":14481053.520000005},null,null,5.1374678442774518E-2,15866719.090000004,null,null,4.9560558790095612E-2,18424774.289999992,null,null,4.8966356458495987E-2,19597452.079999998]
["Q32024","2024Q3",null,null,6.5229919843549533E-2,{"$f":"IFERROR(VLOOKUP($A157,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":18636618.439999983},null,null,6.6161208363452725E-2,20433438.02,null,null,6.189523051165486E-2,23010346.930000007,null,null,6.0697541287896582E-2,24292539.670000006]
["Q42024","2024Q4",null,null,0.10315559003380267,{"$f":"IFERROR(VLOOKUP($A158,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":29472232.619999994},null,null,9.9483523078877908E-2,30724807.679999985,null,null,9.2277857312221823E-2,34305478.680000015,null,null,9.1743627846771827E-2,36717891.230000012]
["Q12025","2025Q1",null,null,0.1750941251777352,{"$f":"IFERROR(VLOOKUP($A159,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":50025546.710000038},null,null,0.16442950635841722,50782931.720000021,null,null,0.15756959253139996,58578519.859999985,null,null,0.15410222656828504,61675223.949999996]
["Q22025","2025Q2",null,null,7.9308797643900586E-2,{"$f":"IFERROR(VLOOKUP($A160,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":22659046.710000001},null,null,7.8274715267952197E-2,24174612.020000003,null,null,7.259923053039713E-2,26989696.420000009,null,null,6.8632765052373132E-2,27468397.110000003]
["Q32025","2025Q3",null,null,1.1018409199717088E-2,{"$f":"IFERROR(VLOOKUP($A161,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3148032.2000000007},null,null,1.0661976683881811E-2,3292878.7900000005,null,null,9.4687207343467118E-3,3520118.55,null,null,9.0540980133799864E-3,3623656.4200000004]
["Q42025","2025Q4",null,null,8.4540511241619157E-3,{"$f":"IFERROR(VLOOKUP($A162,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":2415378.1799999997},null,null,8.2644169622090105E-3,2552408.8199999998,null,null,7.3259645049786699E-3,2723521.4,null,null,7.0127581430495566E-3,2806665.67]
["Q12026","2026Q1",null,null,1.2672880585690029E-2,{"$f":"IFERROR(VLOOKUP($A163,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3620725.59},null,null,1.1744052154691488E-2,3627070.42,null,null,1.1072716506101891E-2,4116424.58,null,null,1.0797898509987662E-2,4321565.1300000008]
["Q22026","2026Q2",null,null,3.9016704569426355E-3,{"$f":"IFERROR(VLOOKUP($A164,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":1114732.9899999998},null,null,4.186155471192902E-3,1292865.5699999998,null,null,3.5788868930475711E-3,1330497.17,null,null,3.3243912742987624E-3,1330497.17]
[]
[null,null,null,null,{"$f":"SUM(E141:E164)","v":1.0000000000000004},{"$f":"SUM(F141:F164)","v":285706597.28999996},{"$f":"F138-F166","v":0},null,1,308843180.55000001,0,null,0.99999999999999978,371762844.08000004,0,null,0.97886495207266389,400222795.76000005,5.9604644775390625E-7]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F169/F$180","v":0},{"$f":"IFERROR(VLOOKUP($A169,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,5.2921023001151188E-2,21180199.780000005]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F170/F$180","v":0},{"$f":"IFERROR(VLOOKUP($A170,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,6.0612186924973693E-2,18719660.589999996,null,null,0.2548602400664095,94747567.689999998,null,null,0.40941777648832445,163858327.1400001]
["13 to 18 months","13 to 18 months",null,null,0.27309063889345109,{"$f":"IFERROR(VLOOKUP($A171,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":78023797.190000027},null,null,0.42294170169916662,130622660.33999993,null,null,0.45332444321341087,168529184.30000013,null,null,0.24702825238192275,98866337.800000057]
["19 to 24 months","19 to 24 months",null,null,0.47395694710735869,{"$f":"IFERROR(VLOOKUP($A172,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":135412626.61999995},null,null,0.2491087304987282,76935532.629999995,null,null,4.3136135994669509E-3,1603641.26,null,null,2.7472922348464868E-2,10995289.790000001]
["25 to 30 months","25 to 30 months",null,null,4.1617863615276696E-3,{"$f":"IFERROR(VLOOKUP($A173,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":1189049.82},null,null,2.7055783958445576E-2,8355994.3699999992,null,null,0.18215317732351899,67717783.260000005,null,null,0.2389215961285252,95621869.170000002]
["31 to 36 months","31 to 36 months",null,null,0.16485047502138481,{"$f":"IFERROR(VLOOKUP($A174,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":47098868.279999986},null,null,0.22474719009948388,69411637.010000065,null,null,8.3876490151043398E-2,31182162.530000012,null,null,4.9692256939622528E-4,198879.74]
["37 to 42 months","37 to 42 months",null,null,7.1232442103332322E-2,{"$f":"IFERROR(VLOOKUP($A175,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":20351578.650000006},null,null,3.0887607694661783E-4,95394.269999999975,null,null,1.4531414545659879E-4,54022.399999999994,null,null,2.8756331778016751E-3,1150893.9500000002]
["43 to 48 months","43 to 48 months",null,null,1.3975736079860398E-4,{"$f":"IFERROR(VLOOKUP($A176,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":39929.599999999977},null,null,3.2348463975174543E-3,999060.25,null,null,1.3641380037722884E-2,5071358.2399999984,null,null,1.93323172042398E-2,7737234.0400000047]
["49 to 54 months","49 to 54 months",null,null,9.1724435307316034E-3,{"$f":"IFERROR(VLOOKUP($A177,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":2620627.6299999994},null,null,1.1403752945841112E-2,3521971.3300000005,null,null,7.525070282166214E-3,2797541.5300000007,null,null,1.5335567001737037E-3,613764.35000000009]
["55 to 60 months","55 to 60 months",null,null,3.3955096214152254E-3,{"$f":"IFERROR(VLOOKUP($A178,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":970119.5},null,null,5.8693139889696728E-4,181269.7600000001,null,null,1.6027118080465911E-4,59582.869999999995,null,null,0,0]
["60+ months","61 to 72 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A179,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
["61 to 72 months","Total",null,null,{"$f":"SUM(E169:E179)","v":1.0000000000000002},{"$f":"SUM(F169:F179)","v":285706597.28999996},{"$f":"F166-F180","v":0},null,1,308843180.54999995,0,null,1,371762844.0800001,0,null,0.99999999999999989,400222795.76000023,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F183/F$189","v":5.0912476498522624E-2},{"$f":"IFERROR(VLOOKUP($A183,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":14546030.419999991},null,null,4.9302344972887838E-2,15226693.02999999,null,null,4.0944191552194115E-2,15221529.100000005,null,null,3.1444269999919311E-2,12584713.650000002]
["13 - 24 months","13-24 Months",null,null,{"$f":"F184/F$189","v":0.19799383653217417},{"$f":"IFERROR(VLOOKUP($A184,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":56568145.31999997},null,null,0.1591232534663134,49144131.700000063,null,null,0.10385062642702383,38607804.240000017,null,null,8.7396246991825743E-2,34977970.309999995]
["25 - 36 months","25-36 Months",null,null,0.30220320597763811,{"$f":"IFERROR(VLOOKUP($A185,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":86341449.669999957},null,null,0.33136206361348469,102338913.64000009,null,null,0.28338471637937335,105351908.13000007,null,null,0.25470614312816287,101939204.70000008]
["37 - 48 months","37-48 Months",null,null,0.414659385375511,{"$f":"IFERROR(VLOOKUP($A186,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":118470922.03000002},null,null,0.40210479816598943,124187324.78000003,null,null,0.35959668675558215,133684686.99000019,null,null,0.3246945979257182,129950179.75000006]
["49 - 60 months","49-60 Months",null,null,3.423109561615402E-2,{"$f":"IFERROR(VLOOKUP($A187,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":9780049.8499999996},null,null,5.8107539781324762E-2,17946117.399999999,null,null,0.20342662370456202,75626460.189999983,null,null,0.28525330568241963,114164875.4999999]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A188,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,8.7971551812644974E-3,3270455.4299999997,null,null,1.6505436271954142E-2,6605851.8499999996]
[null,null,null,null,{"$f":"SUM(E183:E188)","v":1},{"$f":"SUM(F183:F188)","v":285706597.28999996},{"$f":"F180-F189","v":0},null,1,308843180.55000013,0,null,0.99999999999999989,371762844.08000028,0,null,0.99999999999999978,400222795.76000005,0]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F192/F$208","v":3.4347964286029716E-4},{"$f":"IFERROR(VLOOKUP($A192,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":98134.399999999994},null,null,3.4958560460272392E-4,107967.13,null,null,4.3535469608461361E-4,161848.70000000001,null,null,4.3081004337242772E-4,172420]
["02. 21% to 30%","21% to 30%",null,null,3.6963010655580767E-3,{"$f":"IFERROR(VLOOKUP($A193,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":1056057.5999999999},null,null,3.4721470880150862E-3,1072348.9500000002,null,null,4.5313422436522258E-3,1684584.68,null,null,4.5007721176386567E-3,1801311.6]
["03. 31% to 40%","31% to 40%",null,null,2.1392505976318674E-2,{"$f":"IFERROR(VLOOKUP($A194,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":6111980.0900000008},null,null,2.0774291692548099E-2,6415998.3199999994,null,null,2.3789908864848275E-2,8844204.1799999997,null,null,2.3761402175858894E-2,9509854.8100000005]
["04. 41% to 50%","41% to 50%",null,null,5.9651767063330988E-2,{"$f":"IFERROR(VLOOKUP($A195,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":17042903.390000001},null,null,5.8987063782846377E-2,18217752.389999993,null,null,6.5353059798444399E-2,24295839.380000006,null,null,6.3449995100299014E-2,25394134.429999992]
["05. 51% to 60%","51% to 60%",null,null,0.13252271837310214,{"$f":"IFERROR(VLOOKUP($A196,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":37862614.93},null,null,0.13111769768684958,40494806.780000016,null,null,0.13445121282546438,49983965.270000011,null,null,0.1322238800503851,52919010.940000057]
["06. 61% to 70%","61% to 70%",null,null,0.15963336980177029,{"$f":"IFERROR(VLOOKUP($A197,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":45608306.900000051},null,null,0.16127314124695818,49808109.879999973,null,null,0.16221759008552919,60306472.649999954,null,null,0.16101709436022255,64442711.670000046]
["07. 71% to 80%","71% to 80%",null,null,0.19710226328039707,{"$f":"IFERROR(VLOOKUP($A198,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":56313416.959999986},null,null,0.197097804658002,60872312.86999996,null,null,0.19357579474648617,71964288.00000003,null,null,0.19027833213595022,76153726.059999898]
["08. 81% to 90%","81% to 90%",null,null,0.18325287804557294,{"$f":"IFERROR(VLOOKUP($A199,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":52356556.230000019},null,null,0.18300829741276931,56520864.640000023,null,null,0.17493608405364244,65034736.140000053,null,null,0.17702756954525525,70850468.809999943]
["09. 91% to 100%","91% to 100%",null,null,0.24240471675108929,{"$f":"IFERROR(VLOOKUP($A200,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":69256626.790000021},null,null,0.24391997082740818,75333019.589999974,null,null,0.24070965268584829,89486905.079999983,null,null,0.2473101444710171,98979157.440000042]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A201,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E192:E201)","v":0.99999999999999989},{"$f":"SUM(F192:F201)","v":285706597.29000008},{"$f":"F189-F202","v":0},null,0.99999999999999956,308843180.54999995,0,null,1,371762844.08000004,0,null,0.99999999999999911,400222795.75999999,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F205/F$208","v":0.85757495092527836},{"$f":"IFERROR(VLOOKUP($A205,'[7]New v Used'!$A$1:$C$9,3,FALSE),0)","v":245014821.15000013},null,null,0.85728327874520072,264766094.44000006,null,null,0.85603014800348798,318240202.44000006,null,null,0.85077110039025661,340497988.35000038]
["USed","Used",null,null,{"$f":"F206/F$208","v":0.14242504907472167},{"$f":"IFERROR(VLOOKUP($A206,'[7]New v Used'!$A$1:$C$9,3,FALSE),0)","v":40691776.140000008},null,null,0.14271672125479928,44077086.110000007,null,null,0.14396985199651197,53522641.639999963,null,null,0.14922889960974342,59724807.409999929]
["Used"]
[null,null,null,null,{"$f":"SUM(E205:E206)","v":1},{"$f":"SUM(F205:F206)","v":285706597.29000014},{"$f":"F202-F208","v":0},null,1,308843180.55000007,0,null,1,371762844.08000004,0,null,1,400222795.76000029,0]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F211/F$214","v":5.4023952356735466E-3},{"$f":"IFERROR(VLOOKUP($A211,'[7]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":1543499.9599999997},null,null,7.9925376548839796E-3,2468440.75,null,null,1.0234294310437474E-2,3804730.3600000003,null,null,1.2173266069835714E-2,4872018.58]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F212/F$214","v":0.99459760476432657},{"$f":"IFERROR(VLOOKUP($A212,'[7]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":284163097.33000058},null,null,0.99200746234511605,306374739.79999918,null,null,0.98976570568956246,367958113.72000027,null,null,0.98782673393016429,395350777.18000031]
["Hire Purchase","Hire Purchase",null,null,0,{"$f":"IFERROR(VLOOKUP($A213,'[7]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E211:E213)","v":1.0000000000000002},{"$f":"SUM(F211:F213)","v":285706597.29000056},{"$f":"F208-F214","v":0},null,1,308843180.54999918,8.9406967163085938E-7,null,0.99999999999999989,371762844.08000028,0,null,1,400222795.76000029,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F217/F$219","v":0.99981341449408023},{"$f":"IFERROR(VLOOKUP($A217,'[7]Refinance vs Hardship'!$A$1:$C$7,3,FALSE),0)","v":285653288.5800007},null,null,0.99973996644556973,308762870.95999932,null,null,0.99977457607360576,371679039.84000027,null,null,0.99978193865785614,400135522.64000022]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F218/F$219","v":1.8658550591987231E-4},{"$f":"IFERROR(VLOOKUP($A218,'[7]Refinance vs Hardship'!$A$1:$C$7,3,FALSE),0)","v":53308.71},null,null,2.6003355443038025E-4,80309.59,null,null,2.2542392639423112E-4,83804.240000000005,null,null,2.18061342143876E-4,87273.12000000001]
[null,null,null,null,{"$f":"SUM(E217:E218)","v":1},{"$f":"SUM(F217:F218)","v":285706597.29000068},{"$f":"F214-F219","v":0},null,1,308843180.5499993,0,null,1,371762844.08000028,0,null,1,400222795.76000023,0]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F222/F$228","v":1.6715453074233742E-2},{"$f":"IFERROR(VLOOKUP($A222,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":4775715.22},null,null,1.6214878344025001E-2,5007854.5999999996,null,null,1.363012775668777E-2,5067175.0599999996,null,null,1.4772097473291602E-2,5912130.1499999985]
["Annual","Annual",null,null,0.71522517179603251,{"$f":"IFERROR(VLOOKUP($A223,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":204344550.13000044},null,null,0.70736761776947077,218465664.8900001,null,null,0.72434573010220538,269284828.72000015,null,null,0.71645348817649301,286741018.07000023]
["Monthly","Monthly",null,null,0.20692991891254883,{"$f":"IFERROR(VLOOKUP($A224,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":59121243.010000035},null,null,0.21403116689279908,66102066.319999941,null,null,0.20151884356651448,74917218.420000091,null,null,0.20566461051698665,82311665.409999922]
["Quarterly","Quarterly",null,null,1.154874676082771E-2,{"$f":"IFERROR(VLOOKUP($A225,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":3299553.1399999997},null,null,1.1560370358969219E-2,3570341.55,null,null,1.1146004545597667E-2,4143670.35,null,null,1.1422122998564301E-2,4571394]
["Semi Annual","Semi Annual",null,null,2.500400378486475E-2,{"$f":"IFERROR(VLOOKUP($A226,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":7143808.8399999999},null,null,2.6084769123454095E-2,8056103.0600000005,null,null,2.724841678320096E-2,10129948.920000002,null,null,2.9764271191447641E-2,11912339.830000004]
["Structured","Structured",null,null,2.4576705671492574E-2,{"$f":"IFERROR(VLOOKUP($A227,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":7021726.9499999983},null,null,2.4741197511281735E-2,7641150.1299999971,null,null,2.2110877245793619E-2,8220002.6099999994,null,null,2.192340964321687E-2,8774248.3000000026]
["0% to 1%",null,null,null,{"$f":"SUM(E222:E227)","v":1.0000000000000002},{"$f":"SUM(F222:F227)","v":285706597.29000044},{"$f":"F219-F228","v":0},null,1,308843180.55000007,-7.7486038208007813E-7,null,1,371762844.08000028,0,null,1,400222795.76000011,0]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F231/F$245","v":0.2343807469101932},{"$f":"IFERROR(VLOOKUP($A231,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":66964125.670000017},null,null,0.23458140316059506,72448866.650000021,null,null,0.23441835744953193,87148035.270000085,null,null,0.23484566253033451,93990587.629999965]
["02. 1.01% to 2%",null,null,null,0.22510445407993052,{"$f":"IFERROR(VLOOKUP($A232,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":64313827.610000037},null,null,0.22472025082892838,69403317.00000003,null,null,0.22629172852975227,84126856.590000018,null,null,0.2247556444134714,89952332.36999996]
["03. 2.01% to 3%",null,null,null,0.28223494586704212,{"$f":"IFERROR(VLOOKUP($A233,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":80636386.019999996},null,null,0.28268483793141669,87305284.440000027,null,null,0.28030284623488572,104206183.32000008,null,null,0.27802326811170847,111271249.65000004]
["04. 3.01% to 4%",null,null,null,0.18049467379871714,{"$f":"IFERROR(VLOOKUP($A234,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":51568519.080000021},null,null,0.17993270394067631,55570988.570000008,null,null,0.1803948237106997,67064092.719999969,null,null,0.18157180505424597,72669175.450000033]
[null,"< 4%",null,null,{"$f":"SUM(E231:E234)","v":0.92221482065588289},{"$f":"SUM(F231:F234)","v":263482858.38000008},null,null,0.92191919586161641,284728456.66000009,null,null,0.92140775592486956,342545167.90000015,null,null,0.91919638010976035,367883345.10000002]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F236/F$245","v":5.6301531685222346E-2},{"$f":"IFERROR(VLOOKUP($A236,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":16085719.040000005},null,null,5.5520861200378503E-2,17147239.359999992,null,null,5.6455582972362736E-2,20988088.09,null,null,5.8066183626221748E-2,23239410.350000005]
["06. 5.01% to 6%","5% to 6%",null,null,2.0994211463418459E-2,{"$f":"IFERROR(VLOOKUP($A237,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":5998184.7200000025},null,null,2.1706638327132058E-2,6703947.2199999979,null,null,2.1279021171620029E-2,7910749.4299999997,null,null,2.1903905506814106E-2,8766442.3000000026]
["07. 6.01% to 7%","6% to 7%",null,null,4.6098795494845868E-4,{"$f":"IFERROR(VLOOKUP($A238,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":131707.30000000002},null,null,8.2698753310711547E-4,255409.46000000002,null,null,8.1541629247587372E-4,303141.48000000004,null,null,7.9430965294299306E-4,317900.83]
["08. 7.01% to 8%","7% to 8%",null,null,2.8448240527501731E-5,{"$f":"IFERROR(VLOOKUP($A239,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":8127.8499999999985},null,null,2.6317077765892723E-5,8127.8499999999985,null,null,4.2223638671706801E-5,15697.18,null,null,3.9221104260670507E-5,15697.18]
["09. 8.01% to 9%","8% to 9%",null,null,0,{"$f":"IFERROR(VLOOKUP($A240,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP($A241,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP($A242,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A243,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A244,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E235:E244)","v":0.99999999999999967},{"$f":"SUM(F235:F244)","v":285706597.29000014},{"$f":"F228-F245","v":0},null,1,308843180.55000007,0,null,0.99999999999999989,371762844.08000016,0,null,0.99999999999999989,400222795.76000005,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F247/E13","v":2.4077459412032761E-2},{"$f":"SUM('[7]Top 5 Obligor '!$E$2:$E$6)","v":6879088.9999999991},null,null,2.3107388731364902E-2,7136559.4300000006,null,null,2.181961497543955E-2,8111722.1199999992,null,null,2.2380875639505995E-2,8957336.6199999992]